﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Jzy;

namespace FortuneHeaven.Entity.NetBar
{
    public partial class NetBarInfo : EntityBase
    {
        private const string TABLE_NAME = "NetBar";
        private const string INSERT_SQL = "insert into NetBar ( [ID], [NetbarName], [Status], [Contacts], [Telephone], [Address], [License], [RigisterDate], [EffectiveDate], [ExpirationDate], [Experience], [Score]) values ( @ID, @NetbarName, @Status, @Contacts, @Telephone, @Address, @License, @RigisterDate, @EffectiveDate, @ExpirationDate, @Experience, @Score)";
        private const string UPDATE_SQL = "update NetBar set  [ID] = @ID, [NetbarName] = @NetbarName, [Status] = @Status, [Contacts] = @Contacts, [Telephone] = @Telephone, [Address] = @Address, [License] = @License, [RigisterDate] = @RigisterDate, [EffectiveDate] = @EffectiveDate, [ExpirationDate] = @ExpirationDate, [Experience] = @Experience, [Score] = @Score where ID = @ID";
        /// <summary>
        /// 
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public String NetbarName
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Byte? Status
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public String Contacts
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public String Telephone
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public String Address
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public String License
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime RigisterDate
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? EffectiveDate
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? ExpirationDate
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Double Experience
        {
            get;
            set;
        }
        /// <summary>
        /// 
        /// </summary>
        public Int64 Score
        {
            get;
            set;
        }
        public override void SetValue(string key, object value)
        {
            key = key.ToLower();
            switch (key)
            {
                case "id":
                    this.ID = (Int32)value;
                    break;
                case "netbarname":
                    this.NetbarName = (String)value;
                    break;
                case "status":
                    this.Status = (Byte?)value;
                    break;
                case "contacts":
                    this.Contacts = (String)value;
                    break;
                case "telephone":
                    this.Telephone = (String)value;
                    break;
                case "address":
                    this.Address = (String)value;
                    break;
                case "license":
                    this.License = (String)value;
                    break;
                case "rigisterdate":
                    this.RigisterDate = (DateTime)value;
                    break;
                case "effectivedate":
                    this.EffectiveDate = (DateTime?)value;
                    break;
                case "expirationdate":
                    this.ExpirationDate = (DateTime?)value;
                    break;
                case "experience":
                    this.Experience = (Double)value;
                    break;
                case "score":
                    this.Score = (Int64)value;
                    break;
            }
        }
    }



}
